Secchi Depth Rate of Change Analysis

A rate of change is calculated for each station using a seasonal Mann Kendall slope calculation.

get data for params$batch_value

source(here::here(glue::glue("{params$batch_name}/getData.R")))

df <- getData(params$batch_value)

[1] "getting data for Secchi Depth"

create station statistics dataframe

library(here)
library(lubridate)  # for mdy_hms()
library(pander)  # for display
library(dplyr)  # for %>%
library(tidyr)  # for unnest_wider
source(here("R/seasonalMannKendall.R"))

# add statistics for each station
sample_stats_df <- df %>%
  group_by(ProgramName, LocationID) %>%
  summarize(
    mk_results = list(seasonalMannKendall(SampleDate, ResultValue)),
    n_values = n(),
    mean = mean(ResultValue, na.rm = TRUE),
    min = as.numeric(min(ResultValue, na.rm = TRUE)),
    max = as.numeric(max(ResultValue, na.rm = TRUE)),
    coefficient.of.variation = sd(ResultValue, na.rm = TRUE) / mean(ResultValue, na.rm = TRUE),
    .groups = 'drop'
  )

# unnest the seasonal Mann Kendall results
sample_stats_df <- sample_stats_df %>%
  tidyr::unnest_wider(mk_results)

sample_stats_df <- sample_stats_df %>%
  mutate(
    # create column significant_slope
    significant_slope = ifelse(z <= 0.05, slope, NA_real_),
    pvalue = z
  ) %>%
  # drop unwanted columns added by seasonalMannKendall
  select(
    -z,
    -tau,
    -chi_square
  )

# print(head(sample_stats_df))
# # display sample_stats_df with pander
# pander(sample_stats_df)

save stats to csv

dataDir <- here("data", "exports", params$batch_name)

# create dir if does not exist
if (!dir.exists(dataDir)) {
  dir.create(dataDir)
}

# save file
sample_stats_df %>%
  write.csv(paste0(dataDir, "/", params$batch_value, ".csv"))

plot distribution of slopes

library(ggplot2)

ggplot(sample_stats_df, aes(x = slope)) +
  geom_density(fill = "steelblue", alpha = 0.7) +
  labs(title = "Density Plot of Site Slopes",
       x = "Slope (rate of change)",
       y = "Density (log scale)") +
  theme_minimal()

display with gt

library(gt)
library(scales)
library(tidyselect)  # for all_of()
library(RColorBrewer) # for brewer.pal()

# ── color_column() ─────────────────────────────────────────────────────────────
# gt_tbl   : a gt object that you’ve already created (e.g. `sample_stats_df %>% gt()`)
# df       : the original data.frame (must contain the column you want to color)
# column   : a string, e.g. "slope" or "n_values"
# palette  : a character vector of colours to feed to col_numeric()
#
color_column <- function(gt_tbl, df, column, 
                         palette = c("red", "orange", "yellow", "green", "blue", "violet"),
                         domain = NULL) {
  # 1) Pull out that column’s numeric values
  vals <- df[[column]]
  if (!is.numeric(vals)) {
    stop(sprintf("`%s` is not numeric; data_color() requires a numeric column.", column))
  }
  
  # 2) Compute its min and max (ignoring NA)
  min_val <- min(vals, na.rm = TRUE)
  max_val <- max(vals, na.rm = TRUE)
  if (is.null(domain)) {
    domain <- c(min_val, max_val)
  }
  
  # 3) Call data_color() on the gt table for that single column
  gt_tbl %>%
    data_color(
      columns = all_of(column),
      colors  = col_numeric(
        palette = palette,
        domain  = domain
      )
    )
}
library(dplyr)
library(gt)

# 1) First build your gt table as usual:
gt_tbl <- sample_stats_df %>% 
  gt()

# slope blue (-) to red (+) (0 centered)
tryCatch({
  min_slope <- min(sample_stats_df$slope,  na.rm = TRUE)
  max_slope <- max(sample_stats_df$slope,  na.rm = TRUE)
  max_abs_slope <- max(abs(min_slope), abs(max_slope))
  gt_tbl <- color_column(
    gt_tbl, 
    df     = sample_stats_df, 
    column = "slope",
    palette = rev(brewer.pal(11, "RdBu")),
    domain  = c(-max_abs_slope, max_abs_slope)
  )
}, error = function(e) {
  print("Error in slope color column")
  print(e)
})

# slope blue (-) to red (+) (0 centered)
tryCatch({
  min_slope <- min(sample_stats_df$significant_slope,  na.rm = TRUE)
  max_slope <- max(sample_stats_df$significant_slope,  na.rm = TRUE)
  max_abs_slope <- max(abs(min_slope), abs(max_slope))
  gt_tbl <- color_column(
    gt_tbl, 
    df     = sample_stats_df, 
    column = "significant_slope",
    palette = rev(brewer.pal(11, "RdBu")),
    domain  = c(-max_abs_slope, max_abs_slope)
  )
}, error = function(e) {
  print("Error in significant_slope color column")
  print(e)
})

tryCatch({
  # mean values blue to red (0 centered)
  min_mean <- min(sample_stats_df$mean,  na.rm = TRUE)
  max_mean <- max(sample_stats_df$mean,  na.rm = TRUE)
  max_abs_mean <- max(abs(min_mean), abs(max_mean))
  gt_tbl <- color_column(
    gt_tbl, 
    df     = sample_stats_df, 
    column = "mean",
    palette = rev(brewer.pal(11, "RdBu")),
    domain  = c(-max_abs_mean, max_abs_mean)
  )
}, error = function(e) {
  print("Error in mean color column")
  print(e)
})

tryCatch({
  # n values white to green
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "n_values", 
    palette = scales::brewer_pal(palette = "Greens")(9)
  )
}, error = function(e) {
  print("Error in n_values color column")
  print(e)
})

tryCatch({
  # min
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "min", 
    palette = scales::brewer_pal(palette = "Blues")(9)
  )
}, error = function(e) {
  print("Error in min color column")
  print(e)
})

tryCatch({
  # max
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "max", 
    palette = scales::brewer_pal(palette = "Blues")(9)
  )
}, error = function(e) {
  print("Error in max color column")
  print(e)
})

tryCatch({
  # coefficient.of.variation
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "coefficient.of.variation", 
    palette = scales::brewer_pal(palette = "Blues")(9)
  )
}, error = function(e) {
  print("Error in coefficient.of.variation color column")
  print(e)
})

# 4) Render/display:
gt_tbl

ProgramName	LocationID	slope	n_values	mean	min	max	coefficient.of.variation	significant_slope	pvalue
North Biscayne Bay Discrete Water Quality Program	919904	-0.152400000	24	28.7693000	0.6096	670.5600	4.7516253	NA	3.710934e-01
North Biscayne Bay Discrete Water Quality Program	919905	-0.045750000	17	0.5216882	0.3658	0.7010	0.2072712	NA	2.962699e-01
North Biscayne Bay Discrete Water Quality Program	919906	-0.304100000	21	1.0291143	0.5500	1.4020	0.2102996	NA	1.000000e+00
North Biscayne Bay Discrete Water Quality Program	919907	-0.061000000	24	1.0108292	0.6096	1.4000	0.2175904	NA	4.327676e-01
North Biscayne Bay Discrete Water Quality Program	919908	0.245000000	26	2.3259077	1.3600	3.4000	0.2794883	NA	1.000000e+00
North Biscayne Bay Discrete Water Quality Program	919909	-0.276400000	29	1.5720103	1.2192	1.9812	0.1500962	-0.27640000	1.931275e-02
North Biscayne Bay Discrete Water Quality Program	919910	-0.213300000	29	1.1084069	0.8500	1.5545	0.1657806	NA	1.374852e-01
North Biscayne Bay Discrete Water Quality Program	919911	-0.243800000	26	0.9924038	0.6096	1.4326	0.1959010	-0.24380000	2.334220e-02
North Biscayne Bay Discrete Water Quality Program	919912	-0.090000000	31	1.5786903	0.9000	2.8194	0.2744386	NA	8.316721e-01
North Biscayne Bay Discrete Water Quality Program	919913	-0.121900000	29	1.2169655	0.9500	1.4630	0.1146264	NA	7.664327e-01
North Biscayne Bay Discrete Water Quality Program	919914	-0.091400000	29	1.6402069	1.3500	1.9812	0.0886472	NA	4.017356e-01
North Biscayne Bay Discrete Water Quality Program	919915	0.280000000	29	1.8879310	0.8000	2.6900	0.2459508	NA	1.937079e-01
North Biscayne Bay Discrete Water Quality Program	919916	-0.520000000	29	2.5558552	1.4000	3.3528	0.2126805	NA	1.374852e-01
North Biscayne Bay Discrete Water Quality Program	919917	0.312000000	26	1.9487692	1.0000	2.6500	0.2664276	NA	1.336144e-01
North Biscayne Bay Discrete Water Quality Program	919918	0.030000000	29	2.2004138	1.3000	2.8956	0.2557377	NA	7.664327e-01
North Biscayne Bay Discrete Water Quality Program	919919	0.585000000	26	2.5213231	1.0000	3.5000	0.2410503	NA	1.336144e-01
North Biscayne Bay Discrete Water Quality Program	945679	NA	2	1.3000000	1.3000	1.3000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	945680	NA	2	1.4000000	1.4000	1.4000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	945681	NA	2	1.2000000	1.2000	1.2000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	945682	NA	1	0.1524000	0.1524	0.1524	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	945683	NA	1	1.2000000	1.2000	1.2000	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	945684	NA	1	0.0762000	0.0762	0.0762	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	945685	NA	3	1.8133333	1.5500	2.3400	0.2515294	NA	NA
Southeast Florida Water Quality Assessment Survey	1076549	0.183333333	87	4.6603448	1.7500	21.0000	0.7313978	NA	5.781665e-02
Southeast Florida Water Quality Assessment Survey	1076550	0.000000000	92	5.6281870	2.0000	16.0000	0.6529236	NA	4.866958e-01
Southeast Florida Water Quality Assessment Survey	1076551	0.080800000	93	5.9503742	2.0000	18.0000	0.6410797	0.08080000	1.657260e-02
Southeast Florida Water Quality Assessment Survey	1076552	0.166666667	93	5.5402796	2.0000	22.0000	0.6499411	0.16666667	2.977244e-02
Southeast Florida Water Quality Assessment Survey	1076553	0.040685714	93	9.2908731	3.5000	26.0000	0.6689308	NA	4.286714e-01
Southeast Florida Water Quality Assessment Survey	1076554	0.000000000	93	8.2841032	2.5000	24.0000	0.6884151	NA	3.123686e-01
Southeast Florida Water Quality Assessment Survey	1076555	0.041371429	93	9.6779355	3.0000	34.0000	0.7243455	NA	2.212343e-01
Southeast Florida Water Quality Assessment Survey	1076556	0.098733333	92	9.1952783	3.0000	31.0000	0.6943092	NA	2.830523e-01
Southeast Florida Water Quality Assessment Survey	1076557	0.000000000	92	9.1532174	3.0000	26.0000	0.6413578	NA	8.459936e-01
Southeast Florida Water Quality Assessment Survey	1076558	-0.000560000	92	9.1832957	3.5000	35.0000	0.6959445	NA	4.414183e-01
Southeast Florida Water Quality Assessment Survey	1076559	NA	8	8.4687500	3.2500	15.0000	0.4530702	NA	NA
Southeast Florida Water Quality Assessment Survey	1076560	0.166666667	78	10.3750000	3.2500	20.0000	0.3051131	NA	3.595298e-01
Southeast Florida Water Quality Assessment Survey	1076561	0.285714286	74	10.2560811	3.2500	20.0000	0.3267067	NA	1.585311e-01
Southeast Florida Water Quality Assessment Survey	1076562	0.000000000	69	10.9855072	4.0000	19.0000	0.3222119	NA	8.220579e-01
Southeast Florida Water Quality Assessment Survey	1076563	-0.058800000	91	3.4101890	1.0000	11.0000	0.6717568	NA	3.940646e-01
Southeast Florida Water Quality Assessment Survey	1076564	-0.095942857	94	3.1252596	1.2000	10.0000	0.6414666	-0.09594286	5.830242e-03
Southeast Florida Water Quality Assessment Survey	1076565	-0.134800000	94	5.7604936	2.0000	40.0000	0.8926259	-0.13480000	9.307843e-03
Southeast Florida Water Quality Assessment Survey	1076566	0.500000000	92	9.1838174	2.0000	44.0000	0.7519135	0.50000000	2.421342e-02
Southeast Florida Water Quality Assessment Survey	1076567	-0.100000000	93	3.6422280	1.8000	12.0000	0.6789789	-0.10000000	6.307745e-04
Southeast Florida Water Quality Assessment Survey	1076568	-0.300000000	94	5.7973702	2.1000	19.0000	0.6976439	-0.30000000	6.432742e-05
Southeast Florida Water Quality Assessment Survey	1076569	0.480000000	93	8.5921806	2.0000	44.0000	0.6743291	0.48000000	2.692325e-04
Southeast Florida Water Quality Assessment Survey	1076570	-0.239400000	93	4.4325075	1.8000	20.0000	0.7451793	-0.23940000	3.100725e-07
Southeast Florida Water Quality Assessment Survey	1076571	-0.200000000	93	4.2877075	1.8000	12.0000	0.6547736	-0.20000000	4.603158e-06
Southeast Florida Water Quality Assessment Survey	1076572	-0.200000000	93	4.0598796	1.5000	25.2984	0.8157005	-0.20000000	7.085675e-06
Southeast Florida Water Quality Assessment Survey	1076573	2.066666667	10	11.2500000	4.0000	18.0000	0.4360944	NA	6.434288e-01
Southeast Florida Water Quality Assessment Survey	1076574	0.000000000	76	11.7565789	4.0000	21.0000	0.2956730	NA	9.233123e-01
Southeast Florida Water Quality Assessment Survey	1076575	0.000000000	81	11.1790123	3.0000	19.0000	0.3050205	NA	8.237552e-01
Southeast Florida Water Quality Assessment Survey	1076576	0.000000000	79	10.9556962	4.0000	18.0000	0.2995552	NA	5.748471e-01
Southeast Florida Water Quality Assessment Survey	1076577	0.000000000	93	2.8768774	0.5000	15.0000	0.8870444	NA	2.820589e-01
Southeast Florida Water Quality Assessment Survey	1076578	0.333333333	93	8.3944516	1.0000	35.0000	0.5818192	0.33333333	8.944019e-03
Southeast Florida Water Quality Assessment Survey	1076579	0.133333333	93	3.6009118	0.9144	10.0000	0.4987918	0.13333333	2.532629e-02
Southeast Florida Water Quality Assessment Survey	1076580	-0.300000000	93	4.7641634	1.0000	14.0000	0.7816080	-0.30000000	4.632906e-08
Southeast Florida Water Quality Assessment Survey	1076581	0.000000000	80	13.3991800	5.0000	49.0000	0.6339791	NA	9.241257e-01
Southeast Florida Water Quality Assessment Survey	1076582	0.000000000	78	14.5150872	5.0000	50.0000	0.6052031	NA	9.244665e-01
Southeast Florida Water Quality Assessment Survey	1076583	0.050000000	80	14.5406100	5.0000	50.0000	0.6293461	NA	4.068802e-01
Southeast Florida Water Quality Assessment Survey	1076584	-0.174800000	83	16.0637108	5.8000	50.0000	0.6447366	NA	1.159118e-01
Southeast Florida Water Quality Assessment Survey	1076585	0.200000000	74	12.4236432	6.0000	18.8976	0.2482799	NA	2.842941e-01
Southeast Florida Water Quality Assessment Survey	1076586	0.000000000	85	15.4369506	6.0000	49.0000	0.7026897	NA	7.026950e-01
Southeast Florida Water Quality Assessment Survey	1076587	0.300000000	74	13.4938595	5.0000	50.0000	0.5166966	NA	8.850151e-02
Southeast Florida Water Quality Assessment Survey	1076588	0.000000000	83	11.4225157	5.0000	50.0000	0.4910021	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	1076589	0.000000000	77	7.3935065	2.0000	22.0000	0.6763308	NA	2.441606e-01
Southeast Florida Water Quality Assessment Survey	1076590	0.166666667	77	5.4610390	1.5000	11.0000	0.3597787	NA	8.313114e-02
Southeast Florida Water Quality Assessment Survey	1076591	0.183333333	77	5.5844156	1.5000	11.0000	0.3481037	NA	1.613386e-01
Southeast Florida Water Quality Assessment Survey	1076592	-0.300000000	77	6.4142857	1.5000	18.0000	0.6726775	-0.30000000	1.709855e-07
Southeast Florida Water Quality Assessment Survey	1076593	-0.237500000	77	7.9090909	3.0000	20.0000	0.6369248	-0.23750000	2.666682e-03
Southeast Florida Water Quality Assessment Survey	1076594	-0.300000000	77	7.4857143	4.0000	22.0000	0.6716715	-0.30000000	1.071553e-07
Southeast Florida Water Quality Assessment Survey	1076595	-0.116666667	76	9.2342105	3.0000	29.0000	0.6592057	NA	6.932533e-02
Southeast Florida Water Quality Assessment Survey	1076596	0.000000000	77	7.8129870	3.0000	20.0000	0.6358964	NA	1.980954e-01
Southeast Florida Water Quality Assessment Survey	1076597	-0.300000000	77	12.4285714	3.0000	30.0000	0.6492726	-0.30000000	8.315139e-05
Southeast Florida Water Quality Assessment Survey	1076598	-0.175000000	77	13.7961039	4.0000	33.0000	0.6567111	-0.17500000	8.476927e-03
Southeast Florida Water Quality Assessment Survey	1076599	-0.387500000	77	10.2376623	4.0000	27.0000	0.6622665	-0.38750000	2.755541e-03
Southeast Florida Water Quality Assessment Survey	1076600	0.000000000	62	11.4193548	5.0000	20.0000	0.2721365	NA	9.450714e-01
Southeast Florida Water Quality Assessment Survey	1076601	0.000000000	55	11.9545455	6.0000	19.0000	0.2698925	NA	7.540496e-01
Southeast Florida Water Quality Assessment Survey	1076602	NA	2	14.0000000	10.0000	18.0000	0.4040610	NA	NA
Southeast Florida Water Quality Assessment Survey	1076603	0.000000000	64	10.6093750	3.0000	16.0000	0.2707264	NA	6.999194e-01
Southeast Florida Water Quality Assessment Survey	1076604	-0.175000000	90	4.2656000	0.5000	16.0000	0.6833164	-0.17500000	4.248751e-02
Southeast Florida Water Quality Assessment Survey	1076605	0.232500000	93	4.6610753	0.9000	12.0000	0.4826302	0.23250000	1.208145e-02
Southeast Florida Water Quality Assessment Survey	1076606	0.000000000	93	4.5341505	2.0000	15.0000	0.6522637	NA	5.201252e-01
Southeast Florida Water Quality Assessment Survey	1076607	0.250000000	89	9.1661483	1.5000	38.0000	0.4367986	NA	5.758703e-02
Southeast Florida Water Quality Assessment Survey	1076608	0.000000000	93	6.6309333	1.8000	18.0000	0.6443786	NA	9.397573e-01
Southeast Florida Water Quality Assessment Survey	1076609	0.000000000	93	5.9273548	2.0000	16.0000	0.6218397	NA	9.695440e-01
Southeast Florida Water Quality Assessment Survey	1076610	-0.035933333	93	4.6430194	2.0000	14.0000	0.6638573	-0.03593333	4.129832e-02
Southeast Florida Water Quality Assessment Survey	1076611	0.086285714	92	7.6586348	3.0000	28.0000	0.6877679	NA	1.003115e-01
Southeast Florida Water Quality Assessment Survey	1076612	0.000000000	92	6.5992870	1.5000	18.0000	0.6514352	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	1076613	0.100000000	92	9.2125478	3.0000	30.0000	0.6441184	NA	2.216839e-01
Southeast Florida Water Quality Assessment Survey	1076614	NA	8	11.4375000	6.0000	16.0000	0.2699254	NA	NA
Southeast Florida Water Quality Assessment Survey	1076615	0.250000000	76	11.7631579	5.0000	20.0000	0.2845419	NA	3.515683e-01
Southeast Florida Water Quality Assessment Survey	1076616	0.000000000	76	11.8289474	4.0000	20.0000	0.2883038	NA	4.034338e-01
Southeast Florida Water Quality Assessment Survey	1076617	0.000000000	67	11.7611940	6.0000	20.0000	0.2870366	NA	7.754830e-01
Southeast Florida Water Quality Assessment Survey	1076618	0.000000000	89	7.0069213	0.5000	36.0000	0.5755702	NA	4.143458e-01
Southeast Florida Water Quality Assessment Survey	1076619	-0.010200000	92	3.9674739	0.5000	16.0000	0.7245128	NA	1.664833e-01
Southeast Florida Water Quality Assessment Survey	1076620	-0.100000000	92	9.4787913	0.5000	27.0000	0.6689970	-0.10000000	6.885745e-03
Southeast Florida Water Quality Assessment Survey	1076621	0.000000000	87	8.9987586	0.5000	40.0000	0.5467799	NA	6.799657e-01
Southeast Florida Water Quality Assessment Survey	1076622	-0.051520000	91	4.3109670	1.7500	14.0000	0.6374146	NA	5.888886e-02
Southeast Florida Water Quality Assessment Survey	1076623	-0.064200000	92	3.9507739	1.5000	18.0000	0.6943245	NA	7.838389e-02
Southeast Florida Water Quality Assessment Survey	1076624	0.000000000	92	5.0715609	1.2500	36.5760	0.9632545	NA	2.761214e-01
Southeast Florida Water Quality Assessment Survey	1076625	0.500000000	69	13.3542377	4.5000	50.0000	0.4389503	0.50000000	3.504304e-02
Southeast Florida Water Quality Assessment Survey	1076626	0.000000000	92	4.1257217	2.0000	12.0000	0.6394727	NA	4.103569e-01
Southeast Florida Water Quality Assessment Survey	1076627	-0.075000000	91	4.3629319	1.7500	13.0000	0.6307153	-0.07500000	1.661698e-02
Southeast Florida Water Quality Assessment Survey	1076628	0.000000000	89	2.4231281	0.5000	18.0000	0.7724028	NA	9.321001e-01
Southeast Florida Water Quality Assessment Survey	1076629	-0.100000000	93	4.3863441	0.7500	14.0000	0.7197150	-0.10000000	2.291559e-02
Southeast Florida Water Quality Assessment Survey	1076630	-0.066666667	93	3.2677333	0.5000	12.0000	0.7052995	-0.06666667	4.393004e-02
Southeast Florida Water Quality Assessment Survey	1076631	0.000000000	92	3.2221522	0.5000	17.0000	0.5693792	NA	7.194910e-01
Southeast Florida Water Quality Assessment Survey	1076632	0.000000000	92	10.1034348	1.0000	43.0000	0.5704224	NA	9.080047e-01
Southeast Florida Water Quality Assessment Survey	1076633	0.000000000	91	10.9182549	1.2500	48.0000	0.6722973	NA	6.401754e-01
Southeast Florida Water Quality Assessment Survey	1076634	0.000000000	92	10.8413043	1.0000	49.0000	0.6707305	NA	8.778207e-01
Southeast Florida Water Quality Assessment Survey	1076635	0.000000000	90	10.2411111	1.0000	40.0000	0.6731734	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	1076636	0.000000000	89	10.0359551	1.0000	38.0000	0.4554759	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	1076637	0.000000000	87	9.9224138	1.2500	16.2000	0.3511762	NA	8.371825e-01
Southeast Florida Water Quality Assessment Survey	1076638	0.250000000	90	5.9922222	2.0000	14.3000	0.4521698	0.25000000	2.074401e-02
Southeast Florida Water Quality Assessment Survey	1076639	0.000000000	93	5.9641032	2.0000	21.0000	0.6610415	NA	9.398715e-01
Southeast Florida Water Quality Assessment Survey	1076640	0.000000000	93	7.8289032	2.5000	29.0000	0.6521172	NA	4.244731e-01
Southeast Florida Water Quality Assessment Survey	1076641	0.285714286	93	7.0274194	2.0000	14.9000	0.4110855	0.28571429	3.672799e-02
Southeast Florida Water Quality Assessment Survey	1076642	-0.044533333	93	5.8160860	2.4384	40.0000	0.9244150	NA	7.809268e-02
Southeast Florida Water Quality Assessment Survey	1076643	0.000000000	93	8.0077935	2.0000	25.0000	0.6638161	NA	6.223462e-01
Southeast Florida Water Quality Assessment Survey	1076644	0.007000000	93	6.0108129	2.0000	18.0000	0.6643483	NA	3.270151e-01
Southeast Florida Water Quality Assessment Survey	1076645	0.083333333	93	8.6733849	3.0000	30.0000	0.6321949	NA	2.428860e-01
Southeast Florida Water Quality Assessment Survey	1076646	0.000000000	93	7.8313548	2.0000	21.0000	0.6678220	NA	8.193657e-01
Southeast Florida Water Quality Assessment Survey	1076647	-0.006285714	93	10.7480645	3.0000	33.0000	0.7018723	NA	4.965991e-01
Southeast Florida Water Quality Assessment Survey	1076648	NA	6	16.5960000	6.0000	32.0000	0.5424534	NA	NA
Southeast Florida Water Quality Assessment Survey	1076649	0.000000000	87	11.4561195	5.5000	34.0000	0.3484981	NA	9.348711e-01
Southeast Florida Water Quality Assessment Survey	1076650	0.000000000	85	11.8703059	5.0000	34.0000	0.3596281	NA	7.011554e-01
Southeast Florida Water Quality Assessment Survey	1076651	-0.125000000	81	12.1790123	5.0000	34.0000	0.4006370	NA	4.166031e-01
Southeast Florida Water Quality Assessment Survey	1076652	0.000000000	77	1.6922078	0.5000	3.0000	0.3142762	NA	6.591252e-02
Southeast Florida Water Quality Assessment Survey	1076653	0.000000000	76	2.7052632	0.5000	14.0000	0.7283482	NA	8.741357e-01
Southeast Florida Water Quality Assessment Survey	1076654	0.000000000	77	3.4402597	0.5000	7.9000	0.4736146	NA	5.456471e-01
Southeast Florida Water Quality Assessment Survey	1076655	-0.150000000	78	3.2423077	0.5000	12.0000	0.7181124	-0.15000000	3.998187e-02
Southeast Florida Water Quality Assessment Survey	1076656	-0.183333333	76	4.6868421	0.5000	20.0000	0.7940886	NA	1.017248e-01
Southeast Florida Water Quality Assessment Survey	1076657	0.000000000	77	3.3090909	0.5000	7.0000	0.4430597	NA	2.039869e-01
Southeast Florida Water Quality Assessment Survey	1076658	0.000000000	77	5.9766234	0.5000	26.0000	0.7811800	NA	7.633143e-01
Southeast Florida Water Quality Assessment Survey	1076659	0.000000000	77	6.9766234	0.5000	29.0000	0.8209155	NA	9.207709e-01
Southeast Florida Water Quality Assessment Survey	1076660	0.000000000	77	2.3961039	0.5000	10.0000	0.6669073	NA	6.020030e-01
Southeast Florida Water Quality Assessment Survey	1076661	0.000000000	77	6.6363636	0.5000	28.0000	0.8076617	NA	8.017768e-01
Southeast Florida Water Quality Assessment Survey	1076662	0.000000000	77	2.7454545	0.5000	12.0000	0.4960356	NA	4.557584e-01
Southeast Florida Water Quality Assessment Survey	1076663	-0.025000000	77	5.1376623	0.5000	17.0000	0.6763531	NA	4.258238e-01
Southeast Florida Water Quality Assessment Survey	1304651	NA	9	11.8444444	7.0000	16.2000	0.2787111	NA	NA
Southeast Florida Water Quality Assessment Survey	1304921	-0.650000000	20	3.1950000	1.0000	4.3000	0.2513110	NA	1.305700e-01
Southeast Florida Water Quality Assessment Survey	1304980	-0.150000000	20	5.3100000	2.2000	7.0000	0.1942664	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	1305246	0.500000000	20	6.3550000	2.0000	9.1000	0.2876462	NA	1.000000e+00